MS Excel

IMPORTANT

MS Excel: Overview

This topic covers concepts, such as, Windows Home Server, Microsoft Excel, Meaning of Scroll Bar & Microsoft Excel Shortcuts etc.

Important Questions on MS Excel

MEDIUM
IMPORTANT

When a row of data is to be converted into columns _____.

MEDIUM
IMPORTANT

You can use the horizontal and vertical scroll bars to _____.

EASY
IMPORTANT

What is an expression that tells how the numbers in a determined set of cells are to be calculated?

EASY
IMPORTANT

Excel uses the _____ function when creating a data table.

MEDIUM
IMPORTANT

If you need a text to show vertically In a cell. How will you achieve this?

EASY
IMPORTANT

In a worksheet you can select _____.

HARD
IMPORTANT

When you want to insert a blank embedded excel object in a word document you can

HARD
IMPORTANT

Which of the following is not true about Find and Replace in Excel

EASY
IMPORTANT

Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

EASY
IMPORTANT

In Excel, it is acceptable to let long text flow into adjacent cells on a worksheet when-

EASY
IMPORTANT

In Excel you can activate a cell by

MEDIUM
IMPORTANT

Concatenation of text can be done using _____.

MEDIUM
IMPORTANT

An example of a cell address is _____.

MEDIUM
IMPORTANT

What are the tabs that appear at the bottom of each workbook called?

MEDIUM
IMPORTANT

In Excel which of the following is not a worksheet design criterion;

MEDIUM
IMPORTANT

In Excel one want to track the progress of the stock market on a daily basis. Which type of chart should one use?

MEDIUM
IMPORTANT

What happens when you link data maintained in an excel workbook to a word document?

MEDIUM
IMPORTANT

What is represented by the small, black square in the lower-right corner of an active cell or range?

EASY
IMPORTANT

In Excel 3-D reference in a formula

MEDIUM
IMPORTANT

How can you delete a record?